const sequelize = require("../db");
const DataTypes = require("sequelize");
const Student = sequelize.define("students", {
  sNum: {
    type: DataTypes.STRING,
    comment: "学号"
  },
  password: {
    type: DataTypes.STRING,
    comment: "密码"
  },
  grade: {
    type: DataTypes.STRING,
    comment: "年级"
  },
  classes: {
    type: DataTypes.STRING,
    comment: "班级"
  },
  name: {
    type: DataTypes.STRING,
    comment: "姓名"
  },
  sex: {
    type: DataTypes.STRING,
    comment: "性别"
  },
  nation: {
    type: DataTypes.STRING,
    comment: "民族"
  },
  birthdate: {
    type: DataTypes.STRING,
    comment: "出生日期"
  },
  census: {
    type: DataTypes.STRING,
    comment: "户籍"
  },
  parent1: {
    type: DataTypes.STRING,
    comment: "家长1"
  },
  phone1: {
    type: DataTypes.STRING,
    comment: "手机1"
  },
  parent2: {
    type: DataTypes.STRING,
    comment: "家长2"
  },
  phone2: {
    type: DataTypes.STRING,
    comment: "手机2"
  },
  address: {
    type: DataTypes.STRING,
    comment: "地址"
  }
});

module.exports = Student;
